UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7NLYWY60lxbN+a2EHT25/Sa4+OQwTgQsGeq9PuNcgg8='
WHERE
key_id = 'dd0e5243bd3a17b1d1648bb469bba4ffa24388b18a72c5c54c020775e10e34a4'
AND (
token = '7NLYWY60lxbN+a2EHT25/Sa4+OQwTgQsGeq9PuNcgg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)