UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qUzjIRNmE3vir7ocGO98tIu27vRPrNM9Pv2tlDogdlw='
WHERE
key_id = '0bf1e9e21d2c8eb81818e525f29fca9e0226de8e735507265048923d7b64fb73'
AND (
token = 'qUzjIRNmE3vir7ocGO98tIu27vRPrNM9Pv2tlDogdlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)