UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OE7yPxHajU1SeBslNWu1JItwFoJcdaghJCL5+6dSBLU='
WHERE
key_id = 'cbb23f9203ee1e7a240225ad47267238d2491519a15c951520b6ad76d27626ab'
AND (
token = 'OE7yPxHajU1SeBslNWu1JItwFoJcdaghJCL5+6dSBLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)