UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WD5L+0beCGl5AveY8CoFCGNkAUn9IE929qZd8Mie1GA='
WHERE
key_id = '471a302105e851c0ffcda3652be5778f886c215fb9f0eae72d001fa58fdba642'
AND (
token = 'WD5L+0beCGl5AveY8CoFCGNkAUn9IE929qZd8Mie1GA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)