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