UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CUEci3ULiTPy1aNGPQ8UkZGZ76PyL7D4Adb1hzkQKT8='
WHERE
key_id = 'a258acb5a3c675c1d33a8b5efc1cb359478055ad6affe5699211d06765be1e5b'
AND (
token = 'CUEci3ULiTPy1aNGPQ8UkZGZ76PyL7D4Adb1hzkQKT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)