UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nyslBv9cm6fJx+LXhPKG2RRUyFpAx51JHJalz3A5KwA='
WHERE
key_id = '0897ffe13bbc9e1133176c101c946fd3113f8890d6cf8c1d1e1875165c8c7490'
AND (
token = 'nyslBv9cm6fJx+LXhPKG2RRUyFpAx51JHJalz3A5KwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)