UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bnU4doCInhmr5tfc2zEjl6CMzxI9XHMswiayI2RuetE='
WHERE
key_id = '7d1ef87126372e03052ba213ff1d69b1a397140b15eef89be472fea0bafcad5e'
AND (
token = 'bnU4doCInhmr5tfc2zEjl6CMzxI9XHMswiayI2RuetE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)