UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nqBKJ9EP7SWFee/BtLBWZ9wTyKljizb0nKcamWflRYc='
WHERE
key_id = 'cb7e5692c38b19e74397b903e693b58b3f06cb0a16420fb9d83645a3f504f6dc'
AND (
token = 'nqBKJ9EP7SWFee/BtLBWZ9wTyKljizb0nKcamWflRYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)