UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zRBjTG2nzZ3sMSlDiBU9/YCU9xouE2DSyZpEEZlcEq8='
WHERE
key_id = 'b343ef46f6af868985e6a53d22aa1e1f4451511e42259638252712b0e8ba3a45'
AND (
token = 'zRBjTG2nzZ3sMSlDiBU9/YCU9xouE2DSyZpEEZlcEq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)