UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KYtuuP67c3mgYEXGfdEGYkx3xPSZbeJsRkLdDz0ca4s='
WHERE
key_id = '664b028df6491e1de72534e91a59c87b496e540d48808420c410f6dad1ca2aa7'
AND (
token = 'KYtuuP67c3mgYEXGfdEGYkx3xPSZbeJsRkLdDz0ca4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)