UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+SN7Q6TdOgW+1WgHll01vzE+3BYzUwN2mSwyyjCuYZM='
WHERE
key_id = '591a4e51405400d9319286ab32ac12a6a028a82150385cac86b2ca7dc8200465'
AND (
token = '+SN7Q6TdOgW+1WgHll01vzE+3BYzUwN2mSwyyjCuYZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)