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