UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HTPbS0G27QlMZLeUp8PwX9fxsg+1RLAl1skZVOpzPA0='
WHERE
key_id = 'ef5b9f51329a6fa91f050d3a2f61d715fd21f08d7b67e55a072459a41e496b1a'
AND (
token = 'HTPbS0G27QlMZLeUp8PwX9fxsg+1RLAl1skZVOpzPA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)