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