UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Y7KuYZwE5dj3hF6oxOO7hlZjOieftmNMXB6Spz2qME='
WHERE
key_id = '338380c63541dcc839162403e3ccb037331e21a490c311db5df16c75bb647fad'
AND (
token = '9Y7KuYZwE5dj3hF6oxOO7hlZjOieftmNMXB6Spz2qME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)