UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tDPlggl3JB0M5chmHdV1dHY50+fkOHgjU1DQ368BVg8='
WHERE
key_id = '6d5322bd2db0a9449fe4d5bf28add4168fa0d3ae49dfb4e36d80ca6ea78b640a'
AND (
token = 'tDPlggl3JB0M5chmHdV1dHY50+fkOHgjU1DQ368BVg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)