UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KkN5fnoQzTEN1w1WGW9vNSjSwy7Or1BYhEYs0m1pvfM='
WHERE
key_id = '7b9ccaed4ed7286e0a832a74bd83ca57d937b5eaf22186b28a1ca99552d5bf93'
AND (
token = 'KkN5fnoQzTEN1w1WGW9vNSjSwy7Or1BYhEYs0m1pvfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)