UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V6TY8DNzttisV+z/fS9D588iLuCB+D+/6wfNcK+5/7A='
WHERE
key_id = 'a75dba0493b082ff9295de6e8a4f06b49dee2bb443f69969a692dde719716ab7'
AND (
token = 'V6TY8DNzttisV+z/fS9D588iLuCB+D+/6wfNcK+5/7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)