UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZBm6adl9MAHs0YP6s6f2KNwN1NsR9G0mchJHred9PTM='
WHERE
key_id = 'ded3e34d8bb54c28f645d3bdb4c4b700a017a12e78b18ac0ac79e5aba77404c7'
AND (
token = 'ZBm6adl9MAHs0YP6s6f2KNwN1NsR9G0mchJHred9PTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)