UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7gxOCY14iR/b8KmMn53ORLokW4Xty6wBSGU0oiT5LYM='
WHERE
key_id = 'ef6af8495cca22c78a7c3b1a730997fbc35c8059bcd2fb126c839a713e73614d'
AND (
token = '7gxOCY14iR/b8KmMn53ORLokW4Xty6wBSGU0oiT5LYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)