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