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