UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pl1VEYqVwUHWAgod4i3yTjdGClp4/jY2CjvzrOGauaM='
WHERE
key_id = '8ac2fc388ae441009df7fb3a8d130074fc4b74e6fa7913b1b8685d1236c7ddd5'
AND (
token = 'Pl1VEYqVwUHWAgod4i3yTjdGClp4/jY2CjvzrOGauaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)