UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6E8UsTAK463PhYCGSyOBcZEmbOqKIe8hPWAY3vKmjaY='
WHERE
key_id = '7f9bf904031f12c4fad3e93e53fcae1c14b27208a868ebb0a098452bc1fbac8c'
AND (
token = '6E8UsTAK463PhYCGSyOBcZEmbOqKIe8hPWAY3vKmjaY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)