UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PtOdXNissF5YUI+K4VEuH57xRhL+b6ypvLG/6MpmXR0='
WHERE
key_id = '3e1026b26363c28f34c7291e9acb9aa3f90c941d5d993704c363acadea366f03'
AND (
token = 'PtOdXNissF5YUI+K4VEuH57xRhL+b6ypvLG/6MpmXR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)