UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ptj4JdH8MtZ7EExwnxpfF1WBwKb2SX98wiNpYLsgQD0='
WHERE
key_id = '63ad1516784a2338f5e1029b28c47fdd29eb23fc190575857227f004f4a0ab74'
AND (
token = 'ptj4JdH8MtZ7EExwnxpfF1WBwKb2SX98wiNpYLsgQD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)