UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XXHsbKBFo08c2zARlQAtEX8TZMLv6OT68p6f3pDl4TQ='
WHERE
key_id = '02a5684b6451c6aebcda11d640013b9d2682b2893c349b2a66b0b4a8e3498b3e'
AND (
token = 'XXHsbKBFo08c2zARlQAtEX8TZMLv6OT68p6f3pDl4TQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)