UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QyKlTCQjN74Tpd0ewEetj0x21aF+8BVG8dXfm1Einq4='
WHERE
key_id = 'd0fb79e9a834ff89f3545d5c5d9da8b8a9d7d8d6643f2a3d764b08cbb57208df'
AND (
token = 'QyKlTCQjN74Tpd0ewEetj0x21aF+8BVG8dXfm1Einq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)