UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1g3Rx4158Tb4ayA3SE9Be/y6K4JoiBCzfpqPeddUfj8='
WHERE
key_id = '8671c79a4009769f5f0c3a555018edda73264d2d4d998a80003add83016a0132'
AND (
token = '1g3Rx4158Tb4ayA3SE9Be/y6K4JoiBCzfpqPeddUfj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)