UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4XFkV9LYAX+yaeDXVc7y1ajM2kueL1Eo8+aMv89WtTM='
WHERE
key_id = '1d8a523c91238feb00d1de500bdd2975e8ac5bbe60d2161acb52fd51c55dc074'
AND (
token = '4XFkV9LYAX+yaeDXVc7y1ajM2kueL1Eo8+aMv89WtTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)