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