UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hJyQDhofTgGffOf+oApBzV2e5uQCGUvT/sXwfdjIOqI='
WHERE
key_id = '4542ce9e69f7a21ca63bd8382eaecaa4b77ac0ddd1bffb690f547ebabc74f14c'
AND (
token = 'hJyQDhofTgGffOf+oApBzV2e5uQCGUvT/sXwfdjIOqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)