UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1HqeOWjcIMQf1uQeuqbs7eeY7wbjG7t2VPpggjDMgCs='
WHERE
key_id = 'fc427ada5fb9decb9265ec5185594b012fccbb0f1dfb8294788cb61927b824e0'
AND (
token = '1HqeOWjcIMQf1uQeuqbs7eeY7wbjG7t2VPpggjDMgCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)