UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vn6Vv955UPO8KOZOOvumHUinCHtZ+N1xSvtlG2sF/U4='
WHERE
key_id = 'bcc9bd40e75ab1091f9339d03e31dadb97616404b1552af46cfd99f7a67e998f'
AND (
token = 'Vn6Vv955UPO8KOZOOvumHUinCHtZ+N1xSvtlG2sF/U4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)