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