UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Oj1eHDtUNPHypHOgXpIi0Qf2PZu7MmldSDuB9Sttia0='
WHERE
key_id = 'eeb787f5fceda8cd9e576c16cfea18ccda3cf6f49ae63a0e8d0b791568f35f51'
AND (
token = 'Oj1eHDtUNPHypHOgXpIi0Qf2PZu7MmldSDuB9Sttia0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)