UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0BQoMCvGlBYmwFTD+EIkvuLCDHdNK7Y8Jbb+MhZEzvA='
WHERE
key_id = 'dc7b831b623ca4d13c5f57603649a2734cbe76865bbe51535e63138ebb09a5de'
AND (
token = '0BQoMCvGlBYmwFTD+EIkvuLCDHdNK7Y8Jbb+MhZEzvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)