UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPxxQYqs636UhGEaDR1OtsoHZxHOHJupW2FctLGhrJ0='
WHERE
key_id = '0eb54a58558087c7c4b6c45b45fa5e2d4a9e14f4752785a738fcbb6a24a5015b'
AND (
token = 'zPxxQYqs636UhGEaDR1OtsoHZxHOHJupW2FctLGhrJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)