UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/pAZhVvZTL9GlK5jgC4icIwRSNJo/zoLvcZkCE/WQfc='
WHERE
key_id = '07d084803cb8894adb9c3497e6f12c48dde2f5c5055ded0327da2bb23d98ed5e'
AND (
token = '/pAZhVvZTL9GlK5jgC4icIwRSNJo/zoLvcZkCE/WQfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)