UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8BYuTM3u9JwadBdrGa13yzu+3S8AuAn6D6D0+OfTd6E='
WHERE
key_id = '9553d8a3d097a5708d18d47fcc305bcd54360a178bd6c4f12d03c6d002472ebc'
AND (
token = '8BYuTM3u9JwadBdrGa13yzu+3S8AuAn6D6D0+OfTd6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)