UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EIVc+34UDBQsT4RCFTbCq7xUILbk9ky3ya89YSkDpsw='
WHERE
key_id = '6047bdf01efa667fd08160b323b1e7e1fa1d0f93033a861fdd35f2a03de7a49f'
AND (
token = 'EIVc+34UDBQsT4RCFTbCq7xUILbk9ky3ya89YSkDpsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)