UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tOVlfSnsIMFQ2N395/jPQqekYUuIe/bvMV/1k+FxYOw='
WHERE
key_id = 'a1330ddb7e514805d5bd71dcaf12af37ea4fe0ac0650e4aacd793ef7de159d20'
AND (
token = 'tOVlfSnsIMFQ2N395/jPQqekYUuIe/bvMV/1k+FxYOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)