UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xia5MOMGiP0PDWKC6A4OXiIygaG68s//fuXjhfJzIow='
WHERE
key_id = 'e8d463fffb26c9dd7ed2073ed2e980d4e7f33691020d516aa85e597da9763b27'
AND (
token = 'Xia5MOMGiP0PDWKC6A4OXiIygaG68s//fuXjhfJzIow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)